package com.ecoolex.ying.space.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class PickGoodsProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public PickGoodsProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public PickGoodsProductExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public PickGoodsProductExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        PickGoodsProductExample example = new PickGoodsProductExample();
        return example.createCriteria();
    }

    public PickGoodsProductExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public PickGoodsProductExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public PickGoodsProductExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public PickGoodsProductExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public PickGoodsProductExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPickProductIdIsNull() {
            addCriterion("pickgoodsproduct.PickProductId is null");
            return (Criteria) this;
        }

        public Criteria andPickProductIdIsNotNull() {
            addCriterion("pickgoodsproduct.PickProductId is not null");
            return (Criteria) this;
        }

        public Criteria andPickProductIdEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId =", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId <>", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId >", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId >=", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThan(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId <", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickProductId <=", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.PickProductId in", values, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.PickProductId not in", values, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.PickProductId between", value1, value2, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.PickProductId not between", value1, value2, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIsNull() {
            addCriterion("pickgoodsproduct.PickGoodsId is null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIsNotNull() {
            addCriterion("pickgoodsproduct.PickGoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId =", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId <>", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId >", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId >=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThan(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId <", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.PickGoodsId <=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.PickGoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.PickGoodsId in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.PickGoodsId not in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.PickGoodsId between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.PickGoodsId not between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("pickgoodsproduct.GoodsId is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("pickgoodsproduct.GoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.GoodsId <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.GoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.GoodsId in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.GoodsId not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.GoodsId between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.GoodsId not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("pickgoodsproduct.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("pickgoodsproduct.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("pickgoodsproduct.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andSpecIdsIsNull() {
            addCriterion("pickgoodsproduct.SpecIds is null");
            return (Criteria) this;
        }

        public Criteria andSpecIdsIsNotNull() {
            addCriterion("pickgoodsproduct.SpecIds is not null");
            return (Criteria) this;
        }

        public Criteria andSpecIdsEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecIds =", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecIds <>", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsGreaterThan(String value) {
            addCriterion("pickgoodsproduct.SpecIds >", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecIds >=", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsLessThan(String value) {
            addCriterion("pickgoodsproduct.SpecIds <", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecIds <=", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecIds <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecIdsLike(String value) {
            addCriterion("pickgoodsproduct.SpecIds like", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsNotLike(String value) {
            addCriterion("pickgoodsproduct.SpecIds not like", value, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsIn(List<String> values) {
            addCriterion("pickgoodsproduct.SpecIds in", values, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.SpecIds not in", values, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.SpecIds between", value1, value2, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecIdsNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.SpecIds not between", value1, value2, "specIds");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNull() {
            addCriterion("pickgoodsproduct.SpecNames is null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNotNull() {
            addCriterion("pickgoodsproduct.SpecNames is not null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecNames =", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecNames <>", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThan(String value) {
            addCriterion("pickgoodsproduct.SpecNames >", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecNames >=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThan(String value) {
            addCriterion("pickgoodsproduct.SpecNames <", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.SpecNames <=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecNames <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLike(String value) {
            addCriterion("pickgoodsproduct.SpecNames like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotLike(String value) {
            addCriterion("pickgoodsproduct.SpecNames not like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIn(List<String> values) {
            addCriterion("pickgoodsproduct.SpecNames in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.SpecNames not in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.SpecNames between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.SpecNames not between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecSortingIsNull() {
            addCriterion("pickgoodsproduct.SpecSorting is null");
            return (Criteria) this;
        }

        public Criteria andSpecSortingIsNotNull() {
            addCriterion("pickgoodsproduct.SpecSorting is not null");
            return (Criteria) this;
        }

        public Criteria andSpecSortingEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting =", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting <>", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting >", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting >=", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThan(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting <", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SpecSorting <=", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SpecSorting <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.SpecSorting in", values, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.SpecSorting not in", values, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.SpecSorting between", value1, value2, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.SpecSorting not between", value1, value2, "specSorting");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("pickgoodsproduct.`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("pickgoodsproduct.`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("pickgoodsproduct.`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("pickgoodsproduct.`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("pickgoodsproduct.`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Name` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("pickgoodsproduct.`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("pickgoodsproduct.`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("pickgoodsproduct.`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andImageIsNull() {
            addCriterion("pickgoodsproduct.Image is null");
            return (Criteria) this;
        }

        public Criteria andImageIsNotNull() {
            addCriterion("pickgoodsproduct.Image is not null");
            return (Criteria) this;
        }

        public Criteria andImageEqualTo(String value) {
            addCriterion("pickgoodsproduct.Image =", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.Image <>", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThan(String value) {
            addCriterion("pickgoodsproduct.Image >", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.Image >=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThan(String value) {
            addCriterion("pickgoodsproduct.Image <", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.Image <=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Image <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLike(String value) {
            addCriterion("pickgoodsproduct.Image like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotLike(String value) {
            addCriterion("pickgoodsproduct.Image not like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageIn(List<String> values) {
            addCriterion("pickgoodsproduct.Image in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.Image not in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.Image between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.Image not between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andCodedIsNull() {
            addCriterion("pickgoodsproduct.Coded is null");
            return (Criteria) this;
        }

        public Criteria andCodedIsNotNull() {
            addCriterion("pickgoodsproduct.Coded is not null");
            return (Criteria) this;
        }

        public Criteria andCodedEqualTo(String value) {
            addCriterion("pickgoodsproduct.Coded =", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.Coded <>", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThan(String value) {
            addCriterion("pickgoodsproduct.Coded >", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.Coded >=", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLessThan(String value) {
            addCriterion("pickgoodsproduct.Coded <", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.Coded <=", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Coded <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLike(String value) {
            addCriterion("pickgoodsproduct.Coded like", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotLike(String value) {
            addCriterion("pickgoodsproduct.Coded not like", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedIn(List<String> values) {
            addCriterion("pickgoodsproduct.Coded in", values, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.Coded not in", values, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.Coded between", value1, value2, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.Coded not between", value1, value2, "coded");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("pickgoodsproduct.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("pickgoodsproduct.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoodsproduct.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoodsproduct.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoodsproduct.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoodsproduct.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("pickgoodsproduct.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("pickgoodsproduct.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoodsproduct.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoodsproduct.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoodsproduct.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoodsproduct.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoodsproduct.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("pickgoodsproduct.Weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("pickgoodsproduct.Weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.Weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.Weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.Weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.Weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(Integer value) {
            addCriterion("pickgoodsproduct.Weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.Weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Weight <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.Weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.Weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.Weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.Weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andStockNumberIsNull() {
            addCriterion("pickgoodsproduct.StockNumber is null");
            return (Criteria) this;
        }

        public Criteria andStockNumberIsNotNull() {
            addCriterion("pickgoodsproduct.StockNumber is not null");
            return (Criteria) this;
        }

        public Criteria andStockNumberEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber =", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber <>", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber >", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber >=", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThan(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber <", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.StockNumber <=", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.StockNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.StockNumber in", values, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.StockNumber not in", values, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.StockNumber between", value1, value2, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.StockNumber not between", value1, value2, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberIsNull() {
            addCriterion("pickgoodsproduct.UsedStockNumber is null");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberIsNotNull() {
            addCriterion("pickgoodsproduct.UsedStockNumber is not null");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber =", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber <>", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber >", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber >=", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberLessThan(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber <", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.UsedStockNumber <=", value, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UsedStockNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.UsedStockNumber in", values, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.UsedStockNumber not in", values, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.UsedStockNumber between", value1, value2, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andUsedStockNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.UsedStockNumber not between", value1, value2, "usedStockNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberIsNull() {
            addCriterion("pickgoodsproduct.SoldNumber is null");
            return (Criteria) this;
        }

        public Criteria andSoldNumberIsNotNull() {
            addCriterion("pickgoodsproduct.SoldNumber is not null");
            return (Criteria) this;
        }

        public Criteria andSoldNumberEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber =", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber <>", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber >", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber >=", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberLessThan(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber <", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.SoldNumber <=", value, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.SoldNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSoldNumberIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.SoldNumber in", values, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.SoldNumber not in", values, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.SoldNumber between", value1, value2, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andSoldNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.SoldNumber not between", value1, value2, "soldNumber");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("pickgoodsproduct.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("pickgoodsproduct.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("pickgoodsproduct.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("pickgoodsproduct.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoodsproduct.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("pickgoodsproduct.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoodsproduct.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("pickgoodsproduct.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("pickgoodsproduct.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("pickgoodsproduct.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("pickgoodsproduct.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("pickgoodsproduct.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("pickgoodsproduct.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("pickgoodsproduct.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("pickgoodsproduct.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("pickgoodsproduct.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("pickgoodsproduct.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("pickgoodsproduct.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("pickgoodsproduct.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("pickgoodsproduct.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("pickgoodsproduct.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("pickgoodsproduct.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("pickgoodsproduct.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pickgoodsproduct.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("pickgoodsproduct.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("pickgoodsproduct.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("pickgoodsproduct.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("pickgoodsproduct.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("pickgoodsproduct.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("pickgoodsproduct.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("pickgoodsproduct.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("pickgoodsproduct.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("pickgoodsproduct.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("pickgoodsproduct.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("pickgoodsproduct.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("pickgoodsproduct.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("pickgoodsproduct.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("pickgoodsproduct.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("pickgoodsproduct.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("pickgoodsproduct.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("pickgoodsproduct.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("pickgoodsproduct.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("pickgoodsproduct.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("pickgoodsproduct.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("pickgoodsproduct.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(PickGoodsProduct.Column column) {
            addCriterion(new StringBuilder("pickgoodsproduct.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("pickgoodsproduct.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("pickgoodsproduct.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("pickgoodsproduct.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("pickgoodsproduct.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private PickGoodsProductExample example;

        protected Criteria(PickGoodsProductExample example) {
            super();
            this.example = example;
        }

        public PickGoodsProductExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(PickGoodsProduct.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(PickGoodsProduct.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.ying.space.entity.PickGoodsProductExample example);
    }
}